Search Results for: "25 ACP ammo"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='25 ACP ammo' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 196021 then 1 
 when 39314 then 2 
 when 31911 then 3 
 when 115187 then 4 
 when 19163 then 5 
 when 90162 then 6 
 when 89932 then 7 
 when 12686 then 8 
 when 61126 then 9 
 when 43016 then 10 
 when 24700 then 11 
 when 213591 then 12 
 when 307596 then 13 
 when 49779 then 14 
 when 209317 then 15 
 when 161834 then 16 
 when 38933 then 17 
 when 38934 then 18 
 when 280162 then 19 
 when 155548 then 20 
 when 247711 then 21 
 when 285523 then 22 
 when 285183 then 23 
 when 294955 then 24 
 when 247757 then 25 
 when 268361 then 26 
 when 268412 then 27 
 when 299326 then 28 
 when 279962 then 29 
 when 280852 then 30 
 when 281743 then 31 
 when 281741 then 32 
 when 281167 then 33 
 when 281168 then 34 
 when 282180 then 35 
 when 285180 then 36 
 when 287926 then 37 
 when 113146 then 38 
 when 242408 then 39 
 when 268459 then 40 
 when 247718 then 41 
 when 4772 then 42 
 when 61226 then 43 
 when 247725 then 44 
 when 247727 then 45 
 when 247705 then 46 
 when 247723 then 47 
 when 285770 then 48 
 when 291886 then 49 
 when 247628 then 50 
 when 247625 then 51 
 when 247592 then 52 
 when 111808 then 53 
 when 110204 then 54 
 when 287915 then 55 
 when 277901 then 56 
 when 291887 then 57 
 when 247588 then 58 
 when 305098 then 59 
 when 247589 then 60 
 when 286212 then 61 
 when 24701 then 62 
 when 247697 then 63 
 when 247590 then 64 
 when 24702 then 65 
 when 285360 then 66 
 when 281643 then 67 
 when 204160 then 68 
 when 268294 then 69 
 when 268289 then 70 
 when 288172 then 71 
 when 298713 then 72 
 when 66338 then 73 
 when 150676 then 74 
 when 213592 then 75 
 when 285520 then 76 
 when 225318 then 77 
 when 247773 then 78 
 when 247766 then 79 
 when 268252 then 80 
 when 280161 then 81 
 when 242405 then 82 
 when 133562 then 83 
 when 268419 then 84 
 when 268278 then 85 
 when 288166 then 86 
 when 303407 then 87 
 when 288170 then 88 
 when 296461 then 89 
 when 214225 then 90 
 when 128949 then 91 
 when 268358 then 92 
 when 268295 then 93 
 when 298075 then 94 
 when 285179 then 95 
 when 268287 then 96 
 when 278427 then 97 
 when 94165 then 98 
 when 163069 then 99 
 when 197391 then 100 
 when 168472 then 101 
 when 278390 then 102 
 when 294865 then 103 
 when 61410 then 104 
 when 122004 then 105 
 when 274501 then 106 
 when 283521 then 107 
 when 197559 then 108 
 when 255168 then 109 
 when 281644 then 110 
 when 299021 then 111 
 when 300647 then 112 
 when 61225 then 113 
 when 285177 then 114 
 when 199991 then 115 
 when 42268 then 116 
 when 67426 then 117 
 when 108601 then 118 
 when 282166 then 119 
 when 61750 then 120 
 when 204294 then 121 
 when 247609 then 122 
 when 285348 then 123 
 when 299085 then 124 
 when 19042 then 125 
 when 19343 then 126 
 when 42269 then 127 
 when 117986 then 128 
 when 12666 then 129 
 when 184045 then 130 
 when 19216 then 131 
 when 218044 then 132 
 when 292723 then 133 
 when 135177 then 134 
 when 210471 then 135 
 when 277876 then 136 
 when 273362 then 137 
 when 276022 then 138 
 when 286001 then 139 
 when 268348 then 140 
 when 19342 then 141 
 when 151593 then 142 
 when 202717 then 143 
 when 268401 then 144 
 when 268403 then 145 
 when 268402 then 146 
 when 268293 then 147 
 when 305586 then 148 
 when 305118 then 149 
 when 19341 then 150 
 when 19344 then 151 
 when 268399 then 152 
 when 268395 then 153 
 when 268405 then 154 
 when 268394 then 155 
 when 268404 then 156 
 when 268396 then 157 
 when 268387 then 158 
 when 268398 then 159 
 when 268341 then 160 
 when 268406 then 161 
 when 278352 then 162 
 when 278421 then 163 
 when 268363 then 164 
 when 151725 then 165 
 when 278401 then 166 
 when 250076 then 167 
 when 285915 then 168 
 when 213490 then 169 
 when 279952 then 170 
 when 268400 then 171 
 when 287482 then 172 
 when 274650 then 173 
 when 304683 then 174 
 when 273421 then 175 
 when 249876 then 176 
 when 199253 then 177 
 when 200423 then 178 
 when 248664 then 179 
 when 164622 then 180 
 when 271480 then 181 
 when 164624 then 182 
 when 280835 then 183 
 when 270994 then 184 
 when 301499 then 185 
 when 247700 then 186 
 when 287830 then 187 
 when 294627 then 188 
 when 217327 then 189 
 when 215535 then 190 
 when 248669 then 191 
 when 260807 then 192 
 when 248666 then 193 
 when 183795 then 194 
 when 270968 then 195 
 when 149457 then 196 
 when 56380 then 197 
 when 272649 then 198 
 when 227473 then 199 
 when 221041 then 200 
 when 35069 then 201 
 when 227472 then 202 
 when 276029 then 203 
 when 286231 then 204 
 when 39333 then 205 
 when 202709 then 206 
 when 281685 then 207 
 when 35129 then 208 
 when 262883 then 209 
 when 262852 then 210 
 when 301498 then 211 
 when 203483 then 212 
 when 266869 then 213 
 when 281014 then 214 
 when 276152 then 215 
 when 272141 then 216 
 when 1094 then 217 
 when 252527 then 218 
 when 262998 then 219 
 when 151726 then 220 
 when 217368 then 221 
 when 61279 then 222 
 when 116776 then 223 
 when 61998 then 224 
 when 285551 then 225 
 when 42175 then 226 
 when 263584 then 227 
 when 267148 then 228 
 when 267147 then 229 
 when 252526 then 230 
 when 273407 then 231 
 when 278662 then 232 
 when 42176 then 233 
 when 225325 then 234 
 when 61504 then 235 
 when 282339 then 236 
 when 306777 then 237 
 when 281315 then 238 
 when 263527 then 239 
 when 267988 then 240 
 when 274003 then 241 
 when 269934 then 242 
 when 113170 then 243 
 when 42190 then 244 
 when 300752 then 245 
 when 42345 then 246 
 when 42337 then 247 
 when 267629 then 248 
 when 61828 then 249 
 when 250235 then 250 
 when 268035 then 251 
 when 281280 then 252 
 when 281279 then 253 
 when 281592 then 254 
 when 281278 then 255 
 when 284324 then 256 
 when 284943 then 257 
 when 207043 then 258 
 when 255250 then 259 
 when 263423 then 260 
 when 267145 then 261 
 when 263244 then 262 
 when 125043 then 263 
 when 267146 then 264 
 when 133499 then 265 
 when 273822 then 266 
 when 297577 then 267 
 when 271324 then 268 
 when 271323 then 269 
 when 264857 then 270 
 when 263228 then 271 
 when 42336 then 272 
 when 42334 then 273 
 when 195906 then 274 
 when 254534 then 275 
 when 124790 then 276 
 when 264218 then 277 
 when 19265 then 278 
 when 19273 then 279 
 when 89972 then 280 
 when 264598 then 281 
 when 267326 then 282 
 when 267402 then 283 
 when 268666 then 284 
 when 266770 then 285 
 when 268005 then 286 
 when 117464 then 287 
 when 254503 then 288 
 when 283826 then 289 
 when 263368 then 290 
 when 281277 then 291 
 when 283613 then 292 
 when 260610 then 293 
 when 281318 then 294 
 when 255170 then 295 
 when 256244 then 296 
 when 251090 then 297 
 when 252720 then 298 
 when 273519 then 299 
 when 273460 then 300 
 when 279404 then 301 
 when 284194 then 302 
 when 282997 then 303 
 when 42332 then 304 
 when 281316 then 305 
 when 35130 then 306 
 when 266576 then 307 
 when 42342 then 308 
 when 252020 then 309 
 when 252722 then 310 
 when 267626 then 311 
 when 266937 then 312 
 when 267160 then 313 
 when 267162 then 314 
 when 273517 then 315 
 when 272918 then 316 
 when 270975 then 317 
 when 276898 then 318 
 when 269995 then 319 
 when 283477 then 320 
 when 283474 then 321 
 when 260773 then 322 
 when 261071 then 323 
 when 97434 then 324 
 when 267627 then 325 
 when 266218 then 326 
 when 269854 then 327 
 when 48933 then 328 
 when 61950 then 329 
 when 264073 then 330 
 when 165282 then 331 
 when 302663 then 332 
 when 165287 then 333 
 when 58398 then 334 
 when 252907 then 335 
 when 276030 then 336 
 when 250551 then 337 
 when 261063 then 338 
 when 261066 then 339 
 when 185587 then 340 
 when 198057 then 341 
 when 261068 then 342 
 when 261067 then 343 
 when 267923 then 344 
 when 19359 then 345 
 when 272161 then 346 
 when 282091 then 347 
 when 269073 then 348 
 when 283687 then 349 
 when 19261 then 350 
 when 284635 then 351 
 when 109422 then 352 
 when 24707 then 353 
 when 124556 then 354 
 when 262954 then 355 
 when 255887 then 356 
 when 252906 then 357 
 when 268152 then 358 
 when 253730 then 359 
 when 262814 then 360 
 when 254155 then 361 
 when 264594 then 362 
 when 24750 then 363 
 when 263664 then 364 
 when 272205 then 365 
 when 193217 then 366 
 when 161129 then 367 
 when 217371 then 368 
 when 157892 then 369 
 when 24713 then 370 
 when 24716 then 371 
 when 197120 then 372 
 when 260627 then 373 
 when 255964 then 374 
 when 261838 then 375 
 when 266432 then 376 
 when 264221 then 377 
 when 43018 then 378 
 when 267998 then 379 
 when 192257 then 380 
 when 161127 then 381 
 when 201195 then 382 
 when 251815 then 383 
 when 261069 then 384 
 when 70403 then 385 
 when 83843 then 386 
 when 24711 then 387 
 when 24656 then 388 
 when 132542 then 389 
 when 260811 then 390 
 when 277326 then 391 
 when 257286 then 392 
 when 252528 then 393 
 when 260628 then 394 
 when 309573 then 395 
 when 108378 then 396 
 when 280124 then 397 
 when 159425 then 398 
 when 164083 then 399 
 when 170066 then 400 
 when 161090 then 401 
 when 209804 then 402 
 when 204936 then 403 
 when 161825 then 404 
 when 204157 then 405 
 when 287622 then 406 
 when 24717 then 407 
 when 79544 then 408 
 when 66547 then 409 
 when 35119 then 410 
 when 150677 then 411 
 when 121996 then 412 
 when 35118 then 413 
 when 150678 then 414 
 when 170008 then 415 
 when 227469 then 416 
 when 289970 then 417 
 when 305458 then 418 
 when 35115 then 419 
 when 35114 then 420 
 when 114041 then 421 
 when 150580 then 422 
 when 310068 then 423 
 when 310071 then 424 
 when 213550 then 425 
 when 136472 then 426 
 when 204267 then 427 
 when 233344 then 428 
 when 73431 then 429 
 when 24704 then 430 
 when 69479 then 431 
 when 121994 then 432 
 when 150591 then 433 
 when 150575 then 434 
 when 225429 then 435 
 when 250050 then 436 
 when 263583 then 437 
 when 196205 then 438 
 when 31919 then 439 
 when 290174 then 440 
 when 299336 then 441 
 when 301497 then 442 
 when 279889 then 443 
 when 42347 then 444 
 when 150089 then 445 
 when 150574 then 446 
 when 19093 then 447 
 when 89118 then 448 
 when 43068 then 449 
 when 227468 then 450 
 when 114029 then 451 
 when 39332 then 452 
 when 161837 then 453 
 when 12685 then 454 
 when 107196 then 455 
 when 286956 then 456 
 when 299120 then 457 
 when 209784 then 458 
 when 72706 then 459 
 when 253440 then 460 
 when 208532 then 461 
 when 255035 then 462 
 when 170068 then 463 
 when 62011 then 464 
 when 61492 then 465 
 when 74062 then 466 
 when 61495 then 467 
 when 61493 then 468 
 when 310056 then 469 
 when 77693 then 470 
 when 251745 then 471 
 when 165290 then 472 
 when 252860 then 473 
 when 266771 then 474 
 when 138713 then 475 
 when 35092 then 476 
 when 209029 then 477 
 when 204597 then 478 
 when 129969 then 479 
 when 114030 then 480 
 when 148309 then 481 
 when 214813 then 482 
 when 89970 then 483 
 when 144632 then 484 
 when 61961 then 485 
 when 61960 then 486 
 when 61933 then 487 
 when 74012 then 488 
 when 74022 then 489 
 when 74026 then 490 
 when 74024 then 491 
 when 74072 then 492 
 when 62012 then 493 
 when 74014 then 494 
 when 74060 then 495 
 when 74058 then 496 
 when 74018 then 497 
 when 74034 then 498 
 when 95558 then 499 
 when 310070 then 500 
 when 74038 then 501 
 when 61494 then 502 
 when 277253 then 503 
 when 161130 then 504 
 when 217300 then 505 
 when 221127 then 506 
 when 245022 then 507 
 when 305466 then 508 
 when 1162 then 509 
 when 268774 then 510 
 when 268772 then 511 
 when 124868 then 512 
 when 61962 then 513 
 when 61930 then 514 
 when 74046 then 515 
 when 74066 then 516 
 when 74074 then 517 
 when 61931 then 518 
 when 74056 then 519 
 when 61932 then 520 
 when 74064 then 521 
 when 74054 then 522 
 when 74036 then 523 
 when 74070 then 524 
 when 74032 then 525 
 when 216818 then 526 
 when 61502 then 527 
 when 74016 then 528 
 when 61389 then 529 
 when 199101 then 530 
 when 99974 then 531 
 when 70749 then 532 
 when 70750 then 533 
 when 164364 then 534 
 when 164362 then 535 
 when 276023 then 536 
 when 24728 then 537 
 when 154623 then 538 
 when 154625 then 539 
 when 143957 then 540 
 when 149784 then 541 
 when 267115 then 542 
 when 290145 then 543 
 when 210127 then 544 
 when 306778 then 545 
 when 285027 then 546 
 when 286327 then 547 
 when 179962 then 548 
 when 257288 then 549 
 when 289940 then 550 
 when 61967 then 551 
 when 61378 then 552 
 when 61963 then 553 
 when 173284 then 554 
 when 61966 then 555 
 when 74052 then 556 
 when 113248 then 557 
 when 74042 then 558 
 when 74008 then 559 
 when 199100 then 560 
 when 74004 then 561 
 when 74044 then 562 
 when 62014 then 563 
 when 61811 then 564 
 when 70000 then 565 
 when 268036 then 566 
 when 277070 then 567 
 when 290047 then 568 
 when 290048 then 569 
 when 103902 then 570 
 when 173285 then 571 
 when 133413 then 572 
 when 172052 then 573 
 when 181952 then 574 
 when 220679 then 575 
 when 252768 then 576 
 when 161128 then 577 
 when 269273 then 578 
 when 42348 then 579 
 when 173477 then 580 
 when 202685 then 581 
 when 185575 then 582 
 when 202683 then 583 
 when 204589 then 584 
 when 250125 then 585 
 when 276869 then 586 
 when 144630 then 587 
 when 310025 then 588 
 when 216501 then 589 
 when 185574 then 590 
 when 161434 then 591 
 when 202772 then 592 
 when 219952 then 593 
 when 219950 then 594 
 when 250051 then 595 
 when 164589 then 596 
 when 202770 then 597 
 when 61503 then 598 
 when 61969 then 599 
 when 61380 then 600 
 when 61964 then 601 
 when 61968 then 602 
 when 61870 then 603 
 when 74002 then 604 
 when 74030 then 605 
 when 104152 then 606 
 when 281591 then 607 
 when 72616 then 608 
 when 72618 then 609 
 when 286923 then 610 
 when 61379 then 611 
 when 209186 then 612 
 when 219788 then 613 
 when 297989 then 614 
 when 126729 then 615 
 when 126733 then 616 
 when 42341 then 617 
 when 129606 then 618 
 when 70751 then 619 
 when 102206 then 620 
 when 117240 then 621 
 when 117958 then 622 
 when 42346 then 623 
 when 42335 then 624 
 when 221120 then 625 
 when 221121 then 626 
 when 202703 then 627 
 when 221122 then 628 
 when 202700 then 629 
 when 202701 then 630 
 when 202699 then 631 
 when 252721 then 632 
 when 252723 then 633 
 when 217505 then 634 
 when 252728 then 635 
 when 136218 then 636 
 when 19285 then 637 
 when 42321 then 638 
 when 254556 then 639 
 when 260626 then 640 
 when 218049 then 641 
 when 61498 then 642 
 when 61908 then 643 
 when 61909 then 644 
 when 61384 then 645 
 when 61949 then 646 
 when 61496 then 647 
 when 173169 then 648 
 when 72608 then 649 
 when 61874 then 650 
 when 61381 then 651 
 when 61910 then 652 
 when 74020 then 653 
 when 61830 then 654 
 when 203923 then 655 
 when 74010 then 656 
 when 255586 then 657 
 when 61865 then 658 
 when 279895 then 659 
 when 61951 then 660 
 when 72646 then 661 
 when 61868 then 662 
 when 61912 then 663 
 when 281926 then 664 
 when 61873 then 665 
 when 61328 then 666 
 when 61386 then 667 
 when 61497 then 668 
 when 61948 then 669 
 when 61867 then 670 
 when 129292 then 671 
 when 61829 then 672 
 when 88526 then 673 
 when 272921 then 674 
 when 72614 then 675 
 when 217369 then 676 
 when 144914 then 677 
 when 19284 then 678 
 when 117575 then 679 
 when 117576 then 680 
 when 117577 then 681 
 when 42322 then 682 
 when 42344 then 683 
 when 85875 then 684 
 when 216209 then 685 
 when 216204 then 686 
 when 202687 then 687 
 when 185565 then 688 
 when 202689 then 689 
 when 202682 then 690 
 when 185566 then 691 
 when 202688 then 692 
 when 221124 then 693 
 when 252735 then 694 
 when 272519 then 695 
 when 136214 then 696 
 when 263643 then 697 
 when 252733 then 698 
 when 283480 then 699 
 when 185585 then 700 
 when 300928 then 701 
 when 42343 then 702 
 when 185568 then 703 
 when 202691 then 704 
 when 202690 then 705 
 when 202686 then 706 
 when 264742 then 707 
 when 303596 then 708 
 when 19410 then 709 
 when 221163 then 710 
 when 210126 then 711 
 when 305086 then 712 
 when 210124 then 713 
 when 209586 then 714 
 when 35096 then 715 
 when 132670 then 716 
 when 110290 then 717 
 when 70207 then 718 
 when 19282 then 719 
 when 113203 then 720 
 when 117700 then 721 
 when 117771 then 722 
 when 42323 then 723 
 when 102202 then 724 
 when 42324 then 725 
 when 144197 then 726 
 when 42330 then 727 
 when 147963 then 728 
 when 164361 then 729 
 when 127478 then 730 
 when 132672 then 731 
 when 185569 then 732 
 when 204591 then 733 
 when 185577 then 734 
 when 204592 then 735 
 when 185567 then 736 
 when 204593 then 737 
 when 19256 then 738 
 when 202684 then 739 
 when 266407 then 740 
 when 252737 then 741 
 when 252738 then 742 
 when 273514 then 743 
 when 252726 then 744 
 when 298015 then 745 
 when 298016 then 746 
 when 42331 then 747 
 when 164360 then 748 
 when 207503 then 749 
 when 286909 then 750 
 when 161442 then 751 
 when 179484 then 752 
 when 179486 then 753 
 when 191743 then 754 
 when 210125 then 755 
 when 61920 then 756 
 when 61921 then 757 
 when 128528 then 758 
 when 219787 then 759 
 when 61871 then 760 
 when 272920 then 761 
 when 72613 then 762 
 when 203932 then 763 
 when 61383 then 764 
 when 72615 then 765 
 when 61869 then 766 
 when 285019 then 767 
 when 61911 then 768 
 when 72640 then 769 
 when 284607 then 770 
 when 61875 then 771 
 when 88301 then 772 
 when 284606 then 773 
 when 61128 then 774 
 when 61122 then 775 
 when 61130 then 776 
 when 172271 then 777 
 when 248877 then 778 
 when 61134 then 779 
 when 75311 then 780 
 when 135034 then 781 
 when 75331 then 782 
 when 70748 then 783 
 when 19287 then 784 
 when 105803 then 785 
 when 19276 then 786 
 when 116695 then 787 
 when 42325 then 788 
 when 202696 then 789 
 when 221123 then 790 
 when 185561 then 791 
 when 223061 then 792 
 when 185563 then 793 
 when 202692 then 794 
 when 185578 then 795 
 when 217500 then 796 
 when 198018 then 797 
 when 202695 then 798 
 when 202694 then 799 
 when 223169 then 800 
 when 185562 then 801 
 when 202693 then 802 
 when 275723 then 803 
 when 19258 then 804 
 when 276571 then 805 
 when 270351 then 806 
 when 266226 then 807 
 when 279890 then 808 
 when 42360 then 809 
 when 282861 then 810 
 when 304641 then 811 
 when 70747 then 812 
 when 208191 then 813 
 when 210616 then 814 
 when 222180 then 815 
 when 166595 then 816 
 when 261844 then 817 
 when 198241 then 818 
 when 252770 then 819 
 when 109424 then 820 
 when 75326 then 821 
 when 135426 then 822 
 when 135279 then 823 
 when 103481 then 824 
 when 105795 then 825 
 when 75310 then 826 
 when 92298 then 827 
 when 19283 then 828 
 when 92299 then 829 
 when 61137 then 830 
 when 61140 then 831 
 when 19269 then 832 
 when 207501 then 833 
 when 185560 then 834 
 when 198020 then 835 
 when 75334 then 836 
 when 19279 then 837 
 when 198017 then 838 
 when 168791 then 839 
 when 185570 then 840 
 when 129685 then 841 
 when 168789 then 842 
 when 198029 then 843 
 when 92469 then 844 
 when 185559 then 845 
 when 92470 then 846 
 when 162514 then 847 
 when 19278 then 848 
 when 198032 then 849 
 when 217508 then 850 
 when 251884 then 851 
 when 217507 then 852 
 when 195907 then 853 
 when 217506 then 854 
 when 273511 then 855 
 when 276570 then 856 
 when 270353 then 857 
 when 273961 then 858 
 when 119936 then 859 
 when 19260 then 860 
 when 42356 then 861 
 when 251269 then 862 
 when 168790 then 863 
 when 143697 then 864 
 when 61132 then 865 
 when 209609 then 866 
 when 222181 then 867 
 when 179415 then 868 
 when 208919 then 869 
 when 196413 then 870 
 when 209185 then 871 
 when 61922 then 872 
 when 219789 then 873 
 when 61872 then 874 
 when 24724 then 875 
 when 104216 then 876 
 when 61299 then 877 
 when 61321 then 878 
 when 107682 then 879 
 when 137749 then 880 
 when 61322 then 881 
 when 61317 then 882 
 when 202490 then 883 
 when 208192 then 884 
 when 144956 then 885 
 when 82611 then 886 
 when 189445 then 887 
 when 61161 then 888 
 when 12696 then 889 
 when 31932 then 890 
 when 67166 then 891 
 when 250593 then 892 
 when 204935 then 893 
 when 269098 then 894 
 when 208918 then 895 
 when 61136 then 896 
 when 61296 then 897 
 when 225394 then 898 
 when 24729 then 899 
 when 12720 then 900 
 when 12687 then 901 
 when 49862 then 902 
 when 39321 then 903 
 when 227471 then 904 
 when 268840 then 905 
 when 39325 then 906 
 when 289725 then 907 
 when 201200 then 908 
 when 162575 then 909 
 when 61163 then 910 
 when 109120 then 911 
 when 136823 then 912 
 when 105797 then 913 
 when 90618 then 914 
 when 135281 then 915 
 when 98896 then 916 
 when 140004 then 917 
 when 19277 then 918 
 when 102364 then 919 
 when 119935 then 920 
 when 185571 then 921 
 when 19263 then 922 
 when 19264 then 923 
 when 203671 then 924 
 when 185572 then 925 
 when 19281 then 926 
 when 217499 then 927 
 when 207557 then 928 
 when 19280 then 929 
 when 19262 then 930 
 when 19271 then 931 
 when 217503 then 932 
 when 75328 then 933 
 when 19259 then 934 
 when 19347 then 935 
 when 185573 then 936 
 when 119937 then 937 
 when 136213 then 938 
 when 217501 then 939 
 when 12716 then 940 
 when 150679 then 941 
 when 49798 then 942 
 when 179230 then 943 
 when 49781 then 944 
 when 49861 then 945 
 when 209032 then 946 
 when 75719 then 947 
 when 86668 then 948 
 when 24727 then 949 
 when 22913 then 950 
 when 113774 then 951 
 when 222193 then 952 
 when 248329 then 953 
 when 169642 then 954 
 when 210617 then 955 
 when 40290 then 956 
 when 121694 then 957 
 when 24731 then 958 
 when 49780 then 959 
 when 173340 then 960 
 when 251650 then 961 
 when 147232 then 962 
 when 184524 then 963 
 when 271965 then 964 
 when 162875 then 965 
 when 19412 then 966 
 when 111737 then 967 
 when 284110 then 968 
 when 291829 then 969 
 when 163078 then 970 
 when 164638 then 971 
 when 49800 then 972 
 when 39334 then 973 
 when 35084 then 974 
 when 143785 then 975 
 when 61449 then 976 
 when 61460 then 977 
 when 204933 then 978 
 when 220531 then 979 
 when 251197 then 980 
 when 161435 then 981 
 when 11735 then 982 
 when 115469 then 983 
 when 19178 then 984 
 when 19168 then 985 
 when 19171 then 986 
 when 136211 then 987 
 when 143768 then 988 
 when 204159 then 989 
 when 123571 then 990 
 when 250595 then 991 
 when 251648 then 992 
 when 209338 then 993 
 when 126370 then 994 
 when 278985 then 995 
 when 245023 then 996 
 when 250068 then 997 
 when 71838 then 998 
 when 41053 then 999 
 when 117340 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (196021,39314,31911,115187,19163,90162,89932,12686,61126,43016,24700,213591,307596,49779,209317,161834,38933,38934,280162,155548,247711,285523,285183,294955,247757,268361,268412,299326,279962,280852,281743,281741,281167,281168,282180,285180,287926,113146,242408,268459,247718,4772,61226,247725,247727,247705,247723,285770,291886,247628,247625,247592,111808,110204,287915,277901,291887,247588,305098,247589,286212,24701,247697,247590,24702,285360,281643,204160,268294,268289,288172,298713,66338,150676,213592,285520,225318,247773,247766,268252,280161,242405,133562,268419,268278,288166,303407,288170,296461,214225,128949,268358,268295,298075,285179,268287,278427,94165,163069,197391,168472,278390,294865,61410,122004,274501,283521,197559,255168,281644,299021,300647,61225,285177,199991,42268,67426,108601,282166,61750,204294,247609,285348,299085,19042,19343,42269,117986,12666,184045,19216,218044,292723,135177,210471,277876,273362,276022,286001,268348,19342,151593,202717,268401,268403,268402,268293,305586,305118,19341,19344,268399,268395,268405,268394,268404,268396,268387,268398,268341,268406,278352,278421,268363,151725,278401,250076,285915,213490,279952,268400,287482,274650,304683,273421,249876,199253,200423,248664,164622,271480,164624,280835,270994,301499,247700,287830,294627,217327,215535,248669,260807,248666,183795,270968,149457,56380,272649,227473,221041,35069,227472,276029,286231,39333,202709,281685,35129,262883,262852,301498,203483,266869,281014,276152,272141,1094,252527,262998,151726,217368,61279,116776,61998,285551,42175,263584,267148,267147,252526,273407,278662,42176,225325,61504,282339,306777,281315,263527,267988,274003,269934,113170,42190,300752,42345,42337,267629,61828,250235,268035,281280,281279,281592,281278,284324,284943,207043,255250,263423,267145,263244,125043,267146,133499,273822,297577,271324,271323,264857,263228,42336,42334,195906,254534,124790,264218,19265,19273,89972,264598,267326,267402,268666,266770,268005,117464,254503,283826,263368,281277,283613,260610,281318,255170,256244,251090,252720,273519,273460,279404,284194,282997,42332,281316,35130,266576,42342,252020,252722,267626,266937,267160,267162,273517,272918,270975,276898,269995,283477,283474,260773,261071,97434,267627,266218,269854,48933,61950,264073,165282,302663,165287,58398,252907,276030,250551,261063,261066,185587,198057,261068,261067,267923,19359,272161,282091,269073,283687,19261,284635,109422,24707,124556,262954,255887,252906,268152,253730,262814,254155,264594,24750,263664,272205,193217,161129,217371,157892,24713,24716,197120,260627,255964,261838,266432,264221,43018,267998,192257,161127,201195,251815,261069,70403,83843,24711,24656,132542,260811,277326,257286,252528,260628,309573,108378,280124,159425,164083,170066,161090,209804,204936,161825,204157,287622,24717,79544,66547,35119,150677,121996,35118,150678,170008,227469,289970,305458,35115,35114,114041,150580,310068,310071,213550,136472,204267,233344,73431,24704,69479,121994,150591,150575,225429,250050,263583,196205,31919,290174,299336,301497,279889,42347,150089,150574,19093,89118,43068,227468,114029,39332,161837,12685,107196,286956,299120,209784,72706,253440,208532,255035,170068,62011,61492,74062,61495,61493,310056,77693,251745,165290,252860,266771,138713,35092,209029,204597,129969,114030,148309,214813,89970,144632,61961,61960,61933,74012,74022,74026,74024,74072,62012,74014,74060,74058,74018,74034,95558,310070,74038,61494,277253,161130,217300,221127,245022,305466,1162,268774,268772,124868,61962,61930,74046,74066,74074,61931,74056,61932,74064,74054,74036,74070,74032,216818,61502,74016,61389,199101,99974,70749,70750,164364,164362,276023,24728,154623,154625,143957,149784,267115,290145,210127,306778,285027,286327,179962,257288,289940,61967,61378,61963,173284,61966,74052,113248,74042,74008,199100,74004,74044,62014,61811,70000,268036,277070,290047,290048,103902,173285,133413,172052,181952,220679,252768,161128,269273,42348,173477,202685,185575,202683,204589,250125,276869,144630,310025,216501,185574,161434,202772,219952,219950,250051,164589,202770,61503,61969,61380,61964,61968,61870,74002,74030,104152,281591,72616,72618,286923,61379,209186,219788,297989,126729,126733,42341,129606,70751,102206,117240,117958,42346,42335,221120,221121,202703,221122,202700,202701,202699,252721,252723,217505,252728,136218,19285,42321,254556,260626,218049,61498,61908,61909,61384,61949,61496,173169,72608,61874,61381,61910,74020,61830,203923,74010,255586,61865,279895,61951,72646,61868,61912,281926,61873,61328,61386,61497,61948,61867,129292,61829,88526,272921,72614,217369,144914,19284,117575,117576,117577,42322,42344,85875,216209,216204,202687,185565,202689,202682,185566,202688,221124,252735,272519,136214,263643,252733,283480,185585,300928,42343,185568,202691,202690,202686,264742,303596,19410,221163,210126,305086,210124,209586,35096,132670,110290,70207,19282,113203,117700,117771,42323,102202,42324,144197,42330,147963,164361,127478,132672,185569,204591,185577,204592,185567,204593,19256,202684,266407,252737,252738,273514,252726,298015,298016,42331,164360,207503,286909,161442,179484,179486,191743,210125,61920,61921,128528,219787,61871,272920,72613,203932,61383,72615,61869,285019,61911,72640,284607,61875,88301,284606,61128,61122,61130,172271,248877,61134,75311,135034,75331,70748,19287,105803,19276,116695,42325,202696,221123,185561,223061,185563,202692,185578,217500,198018,202695,202694,223169,185562,202693,275723,19258,276571,270351,266226,279890,42360,282861,304641,70747,208191,210616,222180,166595,261844,198241,252770,109424,75326,135426,135279,103481,105795,75310,92298,19283,92299,61137,61140,19269,207501,185560,198020,75334,19279,198017,168791,185570,129685,168789,198029,92469,185559,92470,162514,19278,198032,217508,251884,217507,195907,217506,273511,276570,270353,273961,119936,19260,42356,251269,168790,143697,61132,209609,222181,179415,208919,196413,209185,61922,219789,61872,24724,104216,61299,61321,107682,137749,61322,61317,202490,208192,144956,82611,189445,61161,12696,31932,67166,250593,204935,269098,208918,61136,61296,225394,24729,12720,12687,49862,39321,227471,268840,39325,289725,201200,162575,61163,109120,136823,105797,90618,135281,98896,140004,19277,102364,119935,185571,19263,19264,203671,185572,19281,217499,207557,19280,19262,19271,217503,75328,19259,19347,185573,119937,136213,217501,12716,150679,49798,179230,49781,49861,209032,75719,86668,24727,22913,113774,222193,248329,169642,210617,40290,121694,24731,49780,173340,251650,147232,184524,271965,162875,19412,111737,284110,291829,163078,164638,49800,39334,35084,143785,61449,61460,204933,220531,251197,161435,11735,115469,19178,19168,19171,136211,143768,204159,123571,250595,251648,209338,126370,278985,245023,250068,71838,41053,117340)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'ammo'
 
  and ltrim(rtrim(lower(a.brand))) = 'cci ammunition'
 
	and (a.of3='22 MAGNUM' or a.of3='22 WMR' or a.of3='22LR/22WMR')
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =12666 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=12666 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 12666 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 12666 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Rimfire Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Rimfire Ammunition' and subtyp_1='22 WMR' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=12666  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=12666
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\websites\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\websites\images\
logdir=E:\websites\logs\
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\websites\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-5054; CFGLOBALS=urltoken%3DCFID%23%3D5054%26CFTOKEN%23%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A23%27%7D%23hitcount%3D40%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A02%27%7D%23cftoken%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23cfid%3D5054%23; LAST_NAME=; FIRST_NAME=; PRD_U=147219%2C3731; CUSTOMER_ID=; USERNAME=; EMAIL=; PASSWORD=; CT_U=2359
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/25%20ACP%20ammo/dept/ammo/brand/cci%20ammunition/of3/22%20wmr
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/25 ACP ammo/dept/ammo/brand/cci ammunition/of3/22 wmr
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
hitcount=40
lastvisit={ts '2024-05-20 14:36:23'}
timecreated={ts '2024-05-20 14:36:02'}
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

Cookie Variables:
CFGLOBALS=urltoken=CFID#=5054&CFTOKEN#=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#lastvisit={ts '2024-05-20 14:36:23'}#hitcount=40#timecreated={ts '2024-05-20 14:36:02'}#cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#cfid=5054#
CFID=5054
CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
CT_U=2359
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=147219,3731
USERNAME=

Form Fields:
KWORD=25 ACP ammo
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
cs=/category.cfm/sportsman/belt-holsters/brand/desantis/make/ruger/model/k40
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5054_ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
strarray=Array (0)
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

URL Parameters:
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=cci ammunition
dept=ammo
kword=25 ACP ammo
of3=22 wmr